
#! /bin/bash
export LANG=zh_CN.UTF-8
HIVE_HOME=/usr/bin/hive


${HIVE_HOME} -S -e "

drop table if exists zxedu_dws.dws_signup_count;
create table if not exists zxedu_dws.dws_signup_count
( year_code         string    comment '年份',
  month_code        string    comment '年月',
  dt                string    comment '日期',
  school_id         int       comment '校区id',
  schoool_name      string    comment '校区名称',
  subject_id        int       comment '学科id',
  subjevt_name      string    comment '学科名称',
  origin_type       string    comment '线上线下',
  origin_channel    string    comment '来源渠道',
  tdepart_id        int       comment '咨询中心id',
  tdepart_name      string    comment '咨询中心名称',
  group_type        string    comment '维度类型',
  signup_count      bigint       comment '报名人数',
  relationship_count        bigint       comment '意向人数',
  effective_clue_count      bigint       comment '有效线索人数')
comment '报名主题统计表'
row format delimited fields terminated by '\t'
stored AS orc tblproperties ('orc.compress' = 'SNAPPY');
"
